This is a dbDeveloper FAQ file. FAQ ---------------------------------------------------------------------------------------------- Q: How can I sort using two or more columns? A: To sort on multiple selected columns hold SHIFT down while clicking column headers to set multiple sorted columns; hold CTRL down and click columns area to remove sorting. ---------------------------------------------------------------------------------------------- Q: What expressions can be used to filter data id grid? A: Now for every column you may specify filter statement which is of the form: [RELATIONAL SIGN] STATEMENT where relational sign is one of the following =, <>, <, >, <=, >=. Omitting relational sign has the same effect as using equal sign ('='). Statement is any alphanumerical text which is of a valid data type allowed for the corresponding field. For fields which accept string values you may specify filter mask in the statement substituting masked characters with an asterisk or percent ('*' or '%') symbol. To substitute a single character use underscore ('_') mask symbol. Examples: >20 for Numeric column, <>T*T2 for String column. ---------------------------------------------------------------------------------------------- Q: Sometimes specyfying alias or (table name) and dot I should get Completion Proposal with list of table columns. But instead I get a list of tables. A: That happens when sql parser can't manage with query (it can be not correct, not finished etc.) In that situation parser doesn't know what tables are used in query. So Completion Proposa; doesn't show list of columns but list tables instead. ---------------------------------------------------------------------------------------------- Q: When I'm in Connect dialog and choose Oracle I got an error "TNS ....". My Oracle configuration is correct because I can connect to server using SQL Plus. A: It is because you haven't specified proper path to Oracle directory or you have preinstalled Oracle in other directory. dbDeveloper was asking about that path when you run it for the first time. You can set this Oracle home directory path manually in registy key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME. ---------------------------------------------------------------------------------------------- Q: I connect through ODBC. During calling some queries I got an error: "Invalid descriptor index <13>" A: Some ODBC driver can't execute a query, when BLOB column is not the last column for the query. You need to place BLOB columns at the end of select-item list. ---------------------------------------------------------------------------------------------- Q: What are minimum required files for connect to MS SQL Server? A: Below you can view description for the files, which are required for connectivity to Microsoft SQL Server. You can place the required files in Windows system directory (WinNT\system32 or Win95\system) or any other, which is necessary to add to the PATH environment variable. File Name Description ntwdblib.dll DB-Lib interface library contains functions for the WIN32 API Communication DLL You can use one of the following Net library: / Net Library One library Dbnmpntw.dll - Named Pipes library for used communication protocol. Dbmssocn.dll or dbnetlib.dll (for MSSQL 2000) - TCP/IP Sockets library Dbmsspxn.dll - NWLink IPX/SPX library Dbmsrpcn.dll - Multi-Protocol library If you will use Named Pipes protocol, then it is enough to distribute the following files with your application: Ntwdblib.dll and Dbnmpntw.dll. As since Named Pipes is default Net-Library for MS SQL Client, if Net-Library entry is not exist in registry. When you need to use other Net Library (except Named Pipes), then you need to import the following data(Net Library entry) in the system registry for connect through TCP/IP library (for example): [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo] "DSQUERY"="DBMSSOCN" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\DB-Lib] "AutoAnsiToOem"="on" "UseIntlSettings"="ON" ---------------------------------------------------------------------------------------------- Q: How I can connect to SQL Anywhere(or Adaptive Server Anywhere)? A: First, you need to run SQL Anywhere as Open Server. It’s required Open Server Gateway for SQL Anywhere ver.5 and nothing for SQL Anywhere ver.6 (see SQL Anywhere Manuals for command line options). Second, you need to install Open Client Library (see below). ---------------------------------------------------------------------------------------------- Q: What’s need for Open Client Library deploy? A: For deploying Open Client libraries you need to copy the following files and directories from full installation: File/Directory Name Description \sybase\dll Includes API-interface and communication libraries. Libcomn.dll Open Client and Open Server Common Library Libcs.dll Open Server Library Libct.dll Open Client Library Libintl.dll Locale library Libtcl.dll TLI library Nlmsnmp.dll Named Pipes Driver Nlwnsck.dll WinSock TCP/IP Driver Nlnwlink.dll NWLink IPX/SPX Driver You can use and deploy only one network driver. \sybase\ini Contains initialization files Libtcl.cfg Objectid.dat Sql.ini \sybase\charsets Contains all charsets. You can use and copy only required charsets. In most cases, it is enough “Iso_1” and “Utf8” charset directories. \sybase\locales Contains messages for some code pages. In most cases, it is enough a “English\Iso_1” locale directory. Also you need set SYBASE environment variable to a path, which contains Sybase client, and add drive:\sybase\dll directory to the PATH environment variable. You can add the following line in your autoexec.bat and change X:\ on your valid driver, which contains Sybase client. SET SYBASE=X:\sybase SET PATH=%PATH%;X:\sybase\dll Below you can see a content of Sql.ini for TCP/IP connect, where ASESRV is a SQL Server name, and SRVHOST(port: 5000) is a host with SQL Server. [ASESRV] $BASE$00=NLWNSCK,SRVHOST,5000 MASTER=$BASE$00; $BASE$01=NLWNSCK,SRVHOST,5000 QUERY=$BASE$01; ---------------------------------------------------------------------------------------------- Q: How can I connect to specified serwer. What connection string should I put in "Server name" field? A: - DB2, Informix and ODBC: The "Server name" field can contain DSN, which is set up in ODBC Administrator, or a full datasource string with supported parameters for the required server. Below you can see an example of datasource string for Informix server: 'SERVICE=ids_srv1;HOST=yourhost;PROTOCOL=OLSOCTCP;SERVER=ids_srv1;DATABASE=sysmaster;UID=informix;PWD=informix '. - Interbase: The "Server name" field defines a remote server, path to the required database and network protocol. See examples below. RemoteDatabase value Used network protocol : TCP \\\ NetBEUI @ SPX - Oracle: The property specifies a host string/service name. - MySQL, MS SQL Server or Sybase SQL Server: If you connect to a remote server then "Server name" field has to include server and database names divided by colon. For example, "srv1:pubs" defines database name PUBS on the server SRV1.